HW#2 --- last modified March 02 2019 21:20:13..

Solution set.

Due date: Oct 3

Files to be submitted:
  Ch3Ch4Problems.pdf
  Spool.txt

Purpose: To gain experience with ER, EER, and UML diagrams. To test out your accounts on sigma.

Specification:

Do problems 3.20, 3.21, 4.22, 4.23 out of E&N. Submit these in the file Ch3Ch4Problems.pdf. Then I would like you to test out your Oracle accounts on sigma. I want you to spool an Oracle session into the file Spool.txt in which you log into your Oracle account on sigma and do the following things: First, do a

select * from user_tables;

Secondly, create a table which has a name consisting of your first name and has an integer field which is your last name. Third, insert one row with a value 7 into this table. Lastly, do another

select * from user_tables;

Point Breakdown